Baixem o xampp 1.7.3, ele é melhor...
- Fórum
- OTServ
- Tutoriais
- Tutoriais de Websites
- [Tutorial]Criando Website Com Xampp
[Tutorial]Criando Website Com Xampp
Por ultimate1996, 04 de jun. de 2011 em Tutoriais de Websites
info
Grupo: Herói
Registrado: 25/10/12
Posts: 2.4k
Reputação: +687
Gênero: Masculino
Char no Tibia: Nuncative

Deu Certo Aqui Parabéns e Obrigado REP+
info
Grupo: Campones
Registrado: 23/04/12
Posts: 32
Reputação: 0
Char no Tibia: Chicabuum

info
Grupo: Herói
Registrado: 23/12/08
Posts: 2.4k
Reputação: +359
Gênero: Masculino
Char no Tibia: Gordo Warlike

info
Grupo: Campones
Registrado: 30/08/13
Posts: 16
Reputação: 0

info
Grupo: Campones
Registrado: 30/04/13
Posts: 74
Reputação: +3
Gênero: Masculino
Char no Tibia: Riverwood

Estava tudo certo aqui, até que eu liberei as portas e o mysql não quis mais dar start. Da esse erro aqui:

Erro resolvido, reinstalei o xampp e voltou a funcionar.
Editado Novembro 18 por BorgesRicardo
Me ajudou muito tavo precisando de um topico deste valewwww
info
Grupo: Campones
Registrado: 16/10/11
Posts: 78
Reputação: 0
Char no Tibia: ADMIN

Se alguem puder me ajudar eu to com probleminha na hora de executar meu server meu site ta tudo certim fumcionado so meu servidor que nao quer accesar deta base meu encryption tbm nao muda pra plain meu servidor so acc sha1
accountManager = true namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 655 newPlayerSpawnPosY = 1014 newPlayerSpawnPosZ = 7 newPlayerTownId = 5 newPlayerLevel = 10 newPlayerMagicLevel = 1 generateAccountNumber = false generateAccountSalt = false useFragHandler = true redSkullLength = 50 * 62 * 70 * 90 blackSkullLength = 64 * 72 * 80 * 95 dailyFragsToRedSkull = 150 weeklyFragsToRedSkull = 150 monthlyFragsToRedSkull = 150 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true advancedFragList = false notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 7 * 24 * 60 * 60 killsBanLength = 7 * 24 * 60 * 60 finalBanLength = 30 * 24 * 60 * 60 ipBanishmentLength = 1 * 24 * 60 * 60 broadcastBanishments = true maxViolationCommentSize = 10 violationNameReportActionType = 2 autoBanishUnknownBytes = false worldType = "open" protectionLevel = 60 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 60 * 1000 huntingDuration = 60 * 1000 criticalHitChance = 7 criticalHitMultiplier = 1 displayCriticalHitNotify = false removeWeaponAmmunition = false removeWeaponCharges = true removeRuneCharges = true whiteSkullTime = 15 * 60 * 1000 noDamageToSameLookfeet = false showHealingDamage = true showHealingDamageForMonsters = false fieldOwnershipDuration = 5 * 1000 stopAttackingAtExit = false loginProtectionPeriod = 10 * 1000 deathLostPercent = 6.8 stairhopDelay = 2 * 1000 pushCreatureDelay = 2 * 1000 deathContainerId = 1988 gainExperienceColor = 215 addManaSpentInPvPZone = true squareColor = 0 allowFightback = true fistBaseAttack = 7 worldId = 0 ip = "127.0.0.1" bindOnlyGlobalAddress = false loginPort = 7171 gamePort = 7172 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 1000 motd = "Bem vindo ao Azeroth Server!" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = true allowClones = false serverName = "Azeroth" loginMessage = "Bem vindo ao Azeroth Server!" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113" rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101" rsaPublic = "65537" rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413" rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073" sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "" --- onde coloka senha do meu root que foi criada sqlDatabase = "azerothdetabase" essa e nome da detabase que eu criei sqlFile = "otserv.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "sha1" deathListEnabled = true deathListRequiredTime = 1 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 ingameGuildManagement = true levelToFormGuild = 80 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 20 highscoreDisplayPlayers = 15 updateHighscoresAfterMinutes = 20 buyableAndSellableHouses = true houseNeedPremium = false bedsRequirePremium = false levelToBuyHouse = 100 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 1000 houseRentPeriod = "never" houseCleanOld = 0 guildHalls = false timeBetweenActions = 200 timeBetweenExActions = 1000 hotkeyAimbotEnabled = true mapName = "Azeroth.otbm" mapAuthor = "Luan" randomizeTiles = true storeTrash = true cleanProtectedZones = true mailboxDisabledTowns = "" defaultPriority = "high" niceLevel = 5 coresUsed = "-1" startupDatabaseOptimization = true updatePremiumStateAtStartup = true confirmOutdatedVersion = false formulaLevel = 5.0 formulaMagic = 1.0 bufferMutedOnSpellFailure = false spellNameInsteadOfWords = false emoteSpells = false unifiedSpells = true allowChangeOutfit = true allowChangeColors = true allowChangeAddons = true disableOutfitsForPrivilegedPlayers = false addonsOnlyPremium = true dataDirectory = "data/" logsDirectory = "data/logs/" bankSystem = true displaySkillLevelOnAdvance = false promptExceptionTracerErrorBox = true maximumDoorLevel = 500 maxMessageBuffer = 4 tradeLimit = 100 separateVipListPerCharacter = false vipListDefaultLimit = 20 vipListDefaultPremiumLimit = 100 saveGlobalStorage = true useHouseDataStorage = false storePlayerDirection = false checkCorpseOwner = true monsterLootMessage = 3 monsterLootMessageType = 25 ghostModeInvisibleEffect = false ghostModeSpellEffects = true idleWarningTime = 14 * 60 * 1000 idleKickTime = 15 * 60 * 1000 reportsExpirationAfterReads = 1 playerQueryDeepness = 2 tileLimit = 0 protectionTileLimit = 0 houseTileLimit = 0 freePremium = false premiumForPromotion = false blessings = true blessingOnlyPremium = true blessingReductionBase = 30 blessingReductionDecrement = 5 eachBlessReduction = 8 experienceStages = true rateExperience = 30 rateExperienceFromPlayers = 0 rateSkill = 20.0 rateMagic = 18.0 rateLoot = 2.2 rateSpawn = 1 rateMonsterHealth = 1.0 rateMonsterMana = 1.0 rateMonsterAttack = 1.0 rateMonsterDefense = 1.0 rateStaminaLoss = 1 rateStaminaGain = 3 rateStaminaThresholdGain = 12 staminaRatingLimitTop = 40 * 60 staminaRatingLimitBottom = 14 * 60 staminaLootLimit = 14 * 60 rateStaminaAboveNormal = 1.5 rateStaminaUnderNormal = 0.5 staminaThresholdOnlyPremium = true experienceShareRadiusX = 30 experienceShareRadiusY = 30 experienceShareRadiusZ = 1 experienceShareLevelDifference = 2 / 3 extraPartyExperienceLimit = 20 extraPartyExperiencePercent = 5 experienceShareActivity = 2 * 60 * 1000 globalSaveEnabled = false globalSaveHour = 8 globalSaveMinute = 0 shutdownAtGlobalSave = true cleanMapAtGlobalSave = false deSpawnRange = 2 deSpawnRadius = 50 maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = flse statusPort = 7171 ownerName = "Azeroth" ownerEmail = "luanmax21@hotmail.com" url = "" location = "Brazil" displayGamemastersWithOnlineCommand = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outputLog = "" truncateLogOnStartup = false managerPort = 7171 managerLogs = true managerPassword = "" managerLocalhostOnly = true managerConnectionsLimit = 1 adminPort = 7171 adminLogs = true adminPassword = "" adminLocalhostOnly = true adminConnectionsLimit = 1 adminRequireLogin = true adminEncryption = "" adminEncryptionData = ""
Meu servidor ta assim na hora de ligar
Editado Novembro 29 por Alexclusive
spoiler
info
Grupo: Campones
Registrado: 30/04/13
Posts: 74
Reputação: +3
Gênero: Masculino
Char no Tibia: Riverwood

Se alguem puder me ajudar eu to com probleminha na hora de executar meu server meu site ta tudo certim fumcionado so meu servidor que nao quer accesar deta base meu encryption tbm nao muda pra plain meu servidor so acc sha1
accountManager = true namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 655 newPlayerSpawnPosY = 1014 newPlayerSpawnPosZ = 7 newPlayerTownId = 5 newPlayerLevel = 10 newPlayerMagicLevel = 1 generateAccountNumber = false generateAccountSalt = false useFragHandler = true redSkullLength = 50 * 62 * 70 * 90 blackSkullLength = 64 * 72 * 80 * 95 dailyFragsToRedSkull = 150 weeklyFragsToRedSkull = 150 monthlyFragsToRedSkull = 150 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true advancedFragList = false notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 7 * 24 * 60 * 60 killsBanLength = 7 * 24 * 60 * 60 finalBanLength = 30 * 24 * 60 * 60 ipBanishmentLength = 1 * 24 * 60 * 60 broadcastBanishments = true maxViolationCommentSize = 10 violationNameReportActionType = 2 autoBanishUnknownBytes = false worldType = "open" protectionLevel = 60 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 60 * 1000 huntingDuration = 60 * 1000 criticalHitChance = 7 criticalHitMultiplier = 1 displayCriticalHitNotify = false removeWeaponAmmunition = false removeWeaponCharges = true removeRuneCharges = true whiteSkullTime = 15 * 60 * 1000 noDamageToSameLookfeet = false showHealingDamage = true showHealingDamageForMonsters = false fieldOwnershipDuration = 5 * 1000 stopAttackingAtExit = false loginProtectionPeriod = 10 * 1000 deathLostPercent = 6.8 stairhopDelay = 2 * 1000 pushCreatureDelay = 2 * 1000 deathContainerId = 1988 gainExperienceColor = 215 addManaSpentInPvPZone = true squareColor = 0 allowFightback = true fistBaseAttack = 7 worldId = 0 ip = "127.0.0.1" bindOnlyGlobalAddress = false loginPort = 7171 gamePort = 7172 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 1000 motd = "Bem vindo ao Azeroth Server!" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = true allowClones = false serverName = "Azeroth" loginMessage = "Bem vindo ao Azeroth Server!" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113" rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101" rsaPublic = "65537" rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413" rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073" sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "" --- onde coloka senha do meu root que foi criada sqlDatabase = "azerothdetabase" essa e nome da detabase que eu criei sqlFile = "otserv.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "sha1" deathListEnabled = true deathListRequiredTime = 1 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 ingameGuildManagement = true levelToFormGuild = 80 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 20 highscoreDisplayPlayers = 15 updateHighscoresAfterMinutes = 20 buyableAndSellableHouses = true houseNeedPremium = false bedsRequirePremium = false levelToBuyHouse = 100 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 1000 houseRentPeriod = "never" houseCleanOld = 0 guildHalls = false timeBetweenActions = 200 timeBetweenExActions = 1000 hotkeyAimbotEnabled = true mapName = "Azeroth.otbm" mapAuthor = "Luan" randomizeTiles = true storeTrash = true cleanProtectedZones = true mailboxDisabledTowns = "" defaultPriority = "high" niceLevel = 5 coresUsed = "-1" startupDatabaseOptimization = true updatePremiumStateAtStartup = true confirmOutdatedVersion = false formulaLevel = 5.0 formulaMagic = 1.0 bufferMutedOnSpellFailure = false spellNameInsteadOfWords = false emoteSpells = false unifiedSpells = true allowChangeOutfit = true allowChangeColors = true allowChangeAddons = true disableOutfitsForPrivilegedPlayers = false addonsOnlyPremium = true dataDirectory = "data/" logsDirectory = "data/logs/" bankSystem = true displaySkillLevelOnAdvance = false promptExceptionTracerErrorBox = true maximumDoorLevel = 500 maxMessageBuffer = 4 tradeLimit = 100 separateVipListPerCharacter = false vipListDefaultLimit = 20 vipListDefaultPremiumLimit = 100 saveGlobalStorage = true useHouseDataStorage = false storePlayerDirection = false checkCorpseOwner = true monsterLootMessage = 3 monsterLootMessageType = 25 ghostModeInvisibleEffect = false ghostModeSpellEffects = true idleWarningTime = 14 * 60 * 1000 idleKickTime = 15 * 60 * 1000 reportsExpirationAfterReads = 1 playerQueryDeepness = 2 tileLimit = 0 protectionTileLimit = 0 houseTileLimit = 0 freePremium = false premiumForPromotion = false blessings = true blessingOnlyPremium = true blessingReductionBase = 30 blessingReductionDecrement = 5 eachBlessReduction = 8 experienceStages = true rateExperience = 30 rateExperienceFromPlayers = 0 rateSkill = 20.0 rateMagic = 18.0 rateLoot = 2.2 rateSpawn = 1 rateMonsterHealth = 1.0 rateMonsterMana = 1.0 rateMonsterAttack = 1.0 rateMonsterDefense = 1.0 rateStaminaLoss = 1 rateStaminaGain = 3 rateStaminaThresholdGain = 12 staminaRatingLimitTop = 40 * 60 staminaRatingLimitBottom = 14 * 60 staminaLootLimit = 14 * 60 rateStaminaAboveNormal = 1.5 rateStaminaUnderNormal = 0.5 staminaThresholdOnlyPremium = true experienceShareRadiusX = 30 experienceShareRadiusY = 30 experienceShareRadiusZ = 1 experienceShareLevelDifference = 2 / 3 extraPartyExperienceLimit = 20 extraPartyExperiencePercent = 5 experienceShareActivity = 2 * 60 * 1000 globalSaveEnabled = false globalSaveHour = 8 globalSaveMinute = 0 shutdownAtGlobalSave = true cleanMapAtGlobalSave = false deSpawnRange = 2 deSpawnRadius = 50 maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = flse statusPort = 7171 ownerName = "Azeroth" ownerEmail = "luanmax21@hotmail.com" url = "" location = "Brazil" displayGamemastersWithOnlineCommand = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outputLog = "" truncateLogOnStartup = false managerPort = 7171 managerLogs = true managerPassword = "" managerLocalhostOnly = true managerConnectionsLimit = 1 adminPort = 7171 adminLogs = true adminPassword = "" adminLocalhostOnly = true adminConnectionsLimit = 1 adminRequireLogin = true adminEncryption = "" adminEncryptionData = ""Meu servidor ta assim na hora de ligar
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "" --- onde coloka senha do meu root que foi criada
sqlDatabase = "azerothdetabase" aqui é o nome da sua database
sqlFile = "otserv.s3db" aqui é aonde está sua database (tem q ter o msm nome da database ali em cima), repare se estiver na pasta "schemas", ficará assim: "schemas/otserv.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
Em "sqldatabase" e "sqlfile" os nomes da database tem que ser iguais.
Editado Novembro 29 por Alexclusive
spoiler
info
Grupo: Visconde
Registrado: 22/11/12
Posts: 267
Reputação: +26
Gênero: Masculino
Char no Tibia: ADM Kabo

STEP 3
Add tables and columns to DB
Installer try to add new tables and columns to database.
Add columns to table accountsCan't add column page_lastday to table accounts, already exist?
Can't add column email_new to table accounts, already exist?
Can't add column email_new_time to table accounts, already exist?
Can't add column created to table accounts, already exist?
Can't add column rlname to table accounts, already exist?
Can't add column location to table accounts, already exist?
Can't add column page_access to table accounts, already exist?
Can't add column email_code to table accounts, already exist?
Can't add column next_email to table accounts, already exist?
Can't add column premium_points to table accounts, already exist?
Can't add column vote to table players, already exist?
Can't add column last posts to table accounts, already exist?
Can't add column flag to table accounts, already exist?
Add columns to table guildsCan't add column description to table guilds, already exist?
Can't add column logo_gfx_name to table guilds, already exist?
Add columns to table playersCan't add column created to table players, already exist?
Can't add column nick_verify to table players, already exist?
Can't add column old_name to table players, already exist?
Can't add column hide_char to table players, already exist?
Can't add column worldtransfer to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Add new tables to databaseTable z_news_tickers not added. Already exist?
Table z_spells not added. Already exist?
Table z_monsters not added. Already exist?
Table z_ots_comunication not added. Already exist?
Table z_shop_offer not added. Already exist?
Table z_shop_history_item not added. Already exist?
Table z_shop_history_pacc not added. Already exist?
Table z_polls not added. Already exist?
Table z_polls_answers not added. Already exist?
Table zaypay_payment not added. Already exist?
Table z_bug_tracker not added. Already exist?
Table z_changelog not added. Already exist?
Table z_forum not added. Already exist?
Tables and columns added to database.
Go to STEP 4 - Add samples
STEP 5
Set Admin Account
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 237
info
Grupo: Campones
Registrado: 16/10/11
Posts: 78
Reputação: 0
Char no Tibia: ADMIN

KKK isso eu ja sei acho que o erro que seu executador nao liga em my sql
info
Grupo: Campones
Registrado: 31/12/12
Posts: 19
Reputação: 0
Char no Tibia: The Linux World

Bom tópico cara, só que eu fiz tudo certo pelo 8090 liberei tudo
entrei no site e deu, todo mundo entra só que o accounts, records,
personagens e outros não carrega.
Só carrega o CHAT, itens, saga e talz não sei que ta dando.
Me ajuda alguém ai por favor.
OLHEM O ERRO QUE DA DEPOIS DE UNS 5 MIN
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\site\include.inc.php on line 12
Obrigado. REP++ pra quem me ajuda
(MEU SITE É DE WODBO)
Editado Dezembro 10 por 5584759
info
Grupo: Artesão
Registrado: 03/06/11
Posts: 143
Reputação: +102
Char no Tibia: [ADM] Sakyo








info
Grupo: Herói
Registrado: 23/12/08
Posts: 2.4k
Reputação: +359
Gênero: Masculino
Char no Tibia: Gordo Warlike
liga o apache o mysql né meu caro!